Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 100 |
| Missing cells | 993 |
| Missing cells (%) | 32.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 23.7 KiB |
| Average record size in memory | 242.3 B |
Variable types
| NUM | 24 |
|---|---|
| CAT | 5 |
| BOOL | 1 |
| DATE | 1 |
Reproduction
| Analysis started | 2020-08-07 14:04:27.012286 |
|---|---|
| Analysis finished | 2020-08-07 14:05:17.844453 |
| Duration | 50.83 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
COUNTRY_REGION has constant value "United States" | Constant |
ISO3166_1 has constant value "US" | Constant |
LAST_UPDATED_DATE has constant value "2020-08-07 12:04:04.675800" | Constant |
LAST_REPORTED_FLAG has constant value "False" | Constant |
DATE has a high cardinality: 68 distinct values | High cardinality |
DEATH is highly correlated with POSITIVE and 1 other fields | High correlation |
POSITIVE is highly correlated with DEATH and 3 other fields | High correlation |
HOSPITALIZED is highly correlated with POSITIVE and 3 other fields | High correlation |
TOTAL is highly correlated with NEGATIVE and 1 other fields | High correlation |
NEGATIVE is highly correlated with TOTAL and 1 other fields | High correlation |
TOTAL_SINCE_PREVIOUS_DAY is highly correlated with NEGATIVE_SINCE_PREVIOUS_DAY | High correlation |
NEGATIVE_SINCE_PREVIOUS_DAY is highly correlated with TOTAL_SINCE_PREVIOUS_DAY | High correlation |
HOSPITALIZEDCUMULATIVE is highly correlated with POSITIVE and 3 other fields | High correlation |
HOSPITALIZEDCUMULATIVEINCREASE is highly correlated with HOSPITALIZED_SINCE_PREVIOUS_DAY and 2 other fields | High correlation |
HOSPITALIZED_SINCE_PREVIOUS_DAY is highly correlated with HOSPITALIZEDCUMULATIVEINCREASE | High correlation |
INICUCURRENTLY is highly correlated with HOSPITALIZEDCURRENTLY and 3 other fields | High correlation |
HOSPITALIZEDCURRENTLY is highly correlated with INICUCURRENTLY and 2 other fields | High correlation |
INICUCUMULATIVE is highly correlated with POSITIVE and 9 other fields | High correlation |
INICUCUMULATIVEINCREASE is highly correlated with DEATH_SINCE_PREVIOUS_DAY | High correlation |
DEATH_SINCE_PREVIOUS_DAY is highly correlated with INICUCUMULATIVEINCREASE | High correlation |
ONVENTILATORCURRENTLY is highly correlated with HOSPITALIZED and 6 other fields | High correlation |
ONVENTILATORCUMULATIVE is highly correlated with INICUCUMULATIVE and 1 other fields | High correlation |
NEGATIVE has 4 (4.0%) missing values | Missing |
PENDING has 88 (88.0%) missing values | Missing |
PENDING_SINCE_PREVIOUS_DAY has 88 (88.0%) missing values | Missing |
DEATH has 9 (9.0%) missing values | Missing |
HOSPITALIZED has 45 (45.0%) missing values | Missing |
HOSPITALIZEDCURRENTLY has 28 (28.0%) missing values | Missing |
HOSPITALIZEDCURRENTLYINCREASE has 28 (28.0%) missing values | Missing |
HOSPITALIZEDCUMULATIVE has 45 (45.0%) missing values | Missing |
HOSPITALIZEDCUMULATIVEINCREASE has 45 (45.0%) missing values | Missing |
INICUCURRENTLY has 59 (59.0%) missing values | Missing |
INICUCURRENTLYINCREASE has 60 (60.0%) missing values | Missing |
INICUCUMULATIVE has 89 (89.0%) missing values | Missing |
INICUCUMULATIVEINCREASE has 89 (89.0%) missing values | Missing |
ONVENTILATORCURRENTLY has 64 (64.0%) missing values | Missing |
ONVENTILATORCURRENTLYINCREASE has 64 (64.0%) missing values | Missing |
ONVENTILATORCUMULATIVE has 94 (94.0%) missing values | Missing |
ONVENTILATORCUMULATIVEINCREASE has 94 (94.0%) missing values | Missing |
TOTAL has unique values | Unique |
POSITIVE has 3 (3.0%) zeros | Zeros |
POSITIVE_SINCE_PREVIOUS_DAY has 11 (11.0%) zeros | Zeros |
NEGATIVE_SINCE_PREVIOUS_DAY has 14 (14.0%) zeros | Zeros |
PENDING_SINCE_PREVIOUS_DAY has 2 (2.0%) zeros | Zeros |
DEATH has 5 (5.0%) zeros | Zeros |
DEATH_SINCE_PREVIOUS_DAY has 33 (33.0%) zeros | Zeros |
HOSPITALIZED_SINCE_PREVIOUS_DAY has 54 (54.0%) zeros | Zeros |
TOTAL_SINCE_PREVIOUS_DAY has 5 (5.0%) zeros | Zeros |
HOSPITALIZEDCURRENTLYINCREASE has 7 (7.0%) zeros | Zeros |
HOSPITALIZEDCUMULATIVEINCREASE has 9 (9.0%) zeros | Zeros |
INICUCURRENTLYINCREASE has 7 (7.0%) zeros | Zeros |
INICUCUMULATIVEINCREASE has 2 (2.0%) zeros | Zeros |
ONVENTILATORCURRENTLYINCREASE has 8 (8.0%) zeros | Zeros |
| Distinct count | 1 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 800.0 B |
| United States |
|---|
| Value | Count | Frequency (%) | |
| United States | 100 | 100.0% |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
PROVINCE_STATE
Categorical
| Distinct count | 47 |
|---|---|
| Unique (%) | 47.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 800.0 B |
| Pennsylvania | 5 |
|---|---|
| Connecticut | 4 |
| Massachusetts | 3 |
| Nebraska | 3 |
| California | 3 |
| Other values (42) |
| Value | Count | Frequency (%) | |
| Pennsylvania | 5 | 5.0% | |
| Connecticut | 4 | 4.0% | |
| Massachusetts | 3 | 3.0% | |
| Nebraska | 3 | 3.0% | |
| California | 3 | 3.0% | |
| Michigan | 3 | 3.0% | |
| Wyoming | 3 | 3.0% | |
| Colorado | 3 | 3.0% | |
| Texas | 3 | 3.0% | |
| Montana | 3 | 3.0% | |
| Other values (37) | 67 | 67.0% |
Length
| Max length | 24 |
|---|---|
| Median length | 8 |
| Mean length | 9 |
| Min length | 4 |
| Distinct count | 68 |
|---|---|
| Unique (%) | 68.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 800.0 B |
| 2020-07-07 | 4 |
|---|---|
| 2020-07-13 | 4 |
| 2020-06-19 | 3 |
| 2020-07-29 | 3 |
| 2020-04-14 | 2 |
| Other values (63) |
| Value | Count | Frequency (%) | |
| 2020-07-07 | 4 | 4.0% | |
| 2020-07-13 | 4 | 4.0% | |
| 2020-06-19 | 3 | 3.0% | |
| 2020-07-29 | 3 | 3.0% | |
| 2020-04-14 | 2 | 2.0% | |
| 2020-05-13 | 2 | 2.0% | |
| 2020-07-24 | 2 | 2.0% | |
| 2020-06-15 | 2 | 2.0% | |
| 2020-06-02 | 2 | 2.0% | |
| 2020-05-27 | 2 | 2.0% | |
| Other values (58) | 74 | 74.0% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
| Distinct count | 96 |
|---|---|
| Unique (%) | 96.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35648.86 |
|---|---|
| Minimum | 0 |
| Maximum | 337055 |
| Zeros | 3 |
| Zeros (%) | 3.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 1686.5 |
| median | 10757.5 |
| Q3 | 51549.5 |
| 95-th percentile | 132334.15 |
| Maximum | 337055 |
| Range | 337055 |
| Interquartile range (IQR) | 49863 |
Descriptive statistics
| Standard deviation | 54318.9712 |
|---|---|
| Coefficient of variation (CV) | 1.523722531 |
| Kurtosis | 9.592730881 |
| Mean | 35648.86 |
| Median Absolute Deviation (MAD) | 10731.5 |
| Skewness | 2.639803812 |
| Sum | 3564886 |
| Variance | 2950550633 |
| Value | Count | Frequency (%) | |
| 0 | 3 | 3.0% | |
| 3 | 2 | 2.0% | |
| 133 | 2 | 2.0% | |
| 88970 | 1 | 1.0% | |
| 3743 | 1 | 1.0% | |
| 14624 | 1 | 1.0% | |
| 130593 | 1 | 1.0% | |
| 7105 | 1 | 1.0% | |
| 1060 | 1 | 1.0% | |
| 1787 | 1 | 1.0% | |
| Other values (86) | 86 | 86.0% |
| Value | Count | Frequency (%) | |
| 0 | 3 | 3.0% | |
| 1 | 1 | 1.0% | |
| 3 | 2 | 2.0% | |
| 5 | 1 | 1.0% | |
| 10 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 337055 | 1 | 1.0% | |
| 195571 | 1 | 1.0% | |
| 176783 | 1 | 1.0% | |
| 173033 | 1 | 1.0% | |
| 165416 | 1 | 1.0% |
| Distinct count | 86 |
|---|---|
| Unique (%) | 86.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 604.91 |
|---|---|
| Minimum | -31 |
| Maximum | 5349 |
| Zeros | 11 |
| Zeros (%) | 11.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | -31 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 38.5 |
| median | 198.5 |
| Q3 | 831.25 |
| 95-th percentile | 2193.85 |
| Maximum | 5349 |
| Range | 5380 |
| Interquartile range (IQR) | 792.75 |
Descriptive statistics
| Standard deviation | 979.2991319 |
|---|---|
| Coefficient of variation (CV) | 1.618917082 |
| Kurtosis | 9.252611575 |
| Mean | 604.91 |
| Median Absolute Deviation (MAD) | 196 |
| Skewness | 2.856454203 |
| Sum | 60491 |
| Variance | 959026.7898 |
| Value | Count | Frequency (%) | |
| 0 | 11 | 11.0% | |
| 4 | 3 | 3.0% | |
| 268 | 2 | 2.0% | |
| 42 | 2 | 2.0% | |
| 39 | 1 | 1.0% | |
| 175 | 1 | 1.0% | |
| -31 | 1 | 1.0% | |
| 290 | 1 | 1.0% | |
| 291 | 1 | 1.0% | |
| 2084 | 1 | 1.0% | |
| Other values (76) | 76 | 76.0% |
| Value | Count | Frequency (%) | |
| -31 | 1 | 1.0% | |
| 0 | 11 | 11.0% | |
| 1 | 1 | 1.0% | |
| 4 | 3 | 3.0% | |
| 5 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 5349 | 1 | 1.0% | |
| 4333 | 1 | 1.0% | |
| 4317 | 1 | 1.0% | |
| 4014 | 1 | 1.0% | |
| 2324 | 1 | 1.0% |
| Distinct count | 95 |
|---|---|
| Unique (%) | 99.0% |
| Missing | 4 |
| Missing (%) | 4.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 351568.6354166667 |
|---|---|
| Minimum | 0.0 |
| Maximum | 3498774.0 |
| Zeros | 1 |
| Zeros (%) | 1.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 166.25 |
| Q1 | 24835.5 |
| median | 148095 |
| Q3 | 406865.25 |
| 95-th percentile | 1340490.5 |
| Maximum | 3498774 |
| Range | 3498774 |
| Interquartile range (IQR) | 382029.75 |
Descriptive statistics
| Standard deviation | 569606.7115 |
|---|---|
| Coefficient of variation (CV) | 1.620186371 |
| Kurtosis | 13.39412234 |
| Mean | 351568.6354 |
| Median Absolute Deviation (MAD) | 138432 |
| Skewness | 3.24820474 |
| Sum | 33750589 |
| Variance | 3.244518057e+11 |
| Value | Count | Frequency (%) | |
| 34791 | 2 | 2.0% | |
| 31546 | 1 | 1.0% | |
| 1095992 | 1 | 1.0% | |
| 141027 | 1 | 1.0% | |
| 40138 | 1 | 1.0% | |
| 6978 | 1 | 1.0% | |
| 298705 | 1 | 1.0% | |
| 99808 | 1 | 1.0% | |
| 188425 | 1 | 1.0% | |
| 259927 | 1 | 1.0% | |
| Other values (85) | 85 | 85.0% | |
| (Missing) | 4 | 4.0% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 1.0% | |
| 42 | 1 | 1.0% | |
| 52 | 1 | 1.0% | |
| 131 | 1 | 1.0% | |
| 143 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 3498774 | 1 | 1.0% | |
| 2990286 | 1 | 1.0% | |
| 1614354 | 1 | 1.0% | |
| 1424675 | 1 | 1.0% | |
| 1355417 | 1 | 1.0% |
| Distinct count | 87 |
|---|---|
| Unique (%) | 87.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8167.74 |
|---|---|
| Minimum | -459 |
| Maximum | 96097 |
| Zeros | 14 |
| Zeros (%) | 14.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | -459 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 253.25 |
| median | 2901.5 |
| Q3 | 8825.5 |
| 95-th percentile | 27909.25 |
| Maximum | 96097 |
| Range | 96556 |
| Interquartile range (IQR) | 8572.25 |
Descriptive statistics
| Standard deviation | 14538.4891 |
|---|---|
| Coefficient of variation (CV) | 1.779989214 |
| Kurtosis | 17.79345573 |
| Mean | 8167.74 |
| Median Absolute Deviation (MAD) | 2901.5 |
| Skewness | 3.801995217 |
| Sum | 816774 |
| Variance | 211367665.4 |
| Value | Count | Frequency (%) | |
| 0 | 14 | 14.0% | |
| 552 | 1 | 1.0% | |
| 29 | 1 | 1.0% | |
| 15648 | 1 | 1.0% | |
| 1697 | 1 | 1.0% | |
| 11810 | 1 | 1.0% | |
| 25251 | 1 | 1.0% | |
| 25252 | 1 | 1.0% | |
| 22774 | 1 | 1.0% | |
| 6054 | 1 | 1.0% | |
| Other values (77) | 77 | 77.0% |
| Value | Count | Frequency (%) | |
| -459 | 1 | 1.0% | |
| 0 | 14 | 14.0% | |
| 11 | 1 | 1.0% | |
| 15 | 1 | 1.0% | |
| 29 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 96097 | 1 | 1.0% | |
| 76855 | 1 | 1.0% | |
| 46346 | 1 | 1.0% | |
| 40488 | 1 | 1.0% | |
| 40454 | 1 | 1.0% |
| Distinct count | 11 |
|---|---|
| Unique (%) | 91.7% |
| Missing | 88 |
| Missing (%) | 88.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 404.5 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1242.0 |
| Zeros | 1 |
| Zeros (%) | 1.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.55 |
| Q1 | 5.5 |
| median | 358.5 |
| Q3 | 550 |
| 95-th percentile | 1234.3 |
| Maximum | 1242 |
| Range | 1242 |
| Interquartile range (IQR) | 544.5 |
Descriptive statistics
| Standard deviation | 446.7918979 |
|---|---|
| Coefficient of variation (CV) | 1.104553518 |
| Kurtosis | 0.1958015094 |
| Mean | 404.5 |
| Median Absolute Deviation (MAD) | 320 |
| Skewness | 1.045773679 |
| Sum | 4854 |
| Variance | 199623 |
| Value | Count | Frequency (%) | |
| 550 | 2 | 2.0% | |
| 71 | 1 | 1.0% | |
| 302 | 1 | 1.0% | |
| 1228 | 1 | 1.0% | |
| 6 | 1 | 1.0% | |
| 485 | 1 | 1.0% | |
| 415 | 1 | 1.0% | |
| 0 | 1 | 1.0% | |
| 1242 | 1 | 1.0% | |
| 1 | 1 | 1.0% | |
| (Missing) | 88 | 88.0% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 1.0% | |
| 1 | 1 | 1.0% | |
| 4 | 1 | 1.0% | |
| 6 | 1 | 1.0% | |
| 71 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 1242 | 1 | 1.0% | |
| 1228 | 1 | 1.0% | |
| 550 | 2 | 2.0% | |
| 485 | 1 | 1.0% | |
| 415 | 1 | 1.0% |
| Distinct count | 11 |
|---|---|
| Unique (%) | 91.7% |
| Missing | 88 |
| Missing (%) | 88.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.25 |
|---|---|
| Minimum | -97.0 |
| Maximum | 152.0 |
| Zeros | 2 |
| Zeros (%) | 2.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | -97 |
|---|---|
| 5-th percentile | -64.55 |
| Q1 | -11.5 |
| median | 0 |
| Q3 | 31.75 |
| 95-th percentile | 89.3 |
| Maximum | 152 |
| Range | 249 |
| Interquartile range (IQR) | 43.25 |
Descriptive statistics
| Standard deviation | 59.23470267 |
|---|---|
| Coefficient of variation (CV) | 7.17996396 |
| Kurtosis | 3.137113892 |
| Mean | 8.25 |
| Median Absolute Deviation (MAD) | 33.5 |
| Skewness | 0.8770551808 |
| Sum | 99 |
| Variance | 3508.75 |
| Value | Count | Frequency (%) | |
| 0 | 2 | 2.0% | |
| 19 | 1 | 1.0% | |
| 30 | 1 | 1.0% | |
| -97 | 1 | 1.0% | |
| 152 | 1 | 1.0% | |
| 37 | 1 | 1.0% | |
| -37 | 1 | 1.0% | |
| 38 | 1 | 1.0% | |
| -38 | 1 | 1.0% | |
| -2 | 1 | 1.0% | |
| (Missing) | 88 | 88.0% |
| Value | Count | Frequency (%) | |
| -97 | 1 | 1.0% | |
| -38 | 1 | 1.0% | |
| -37 | 1 | 1.0% | |
| -3 | 1 | 1.0% | |
| -2 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 152 | 1 | 1.0% | |
| 38 | 1 | 1.0% | |
| 37 | 1 | 1.0% | |
| 30 | 1 | 1.0% | |
| 19 | 1 | 1.0% |
| Distinct count | 84 |
|---|---|
| Unique (%) | 92.3% |
| Missing | 9 |
| Missing (%) | 9.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2051.7582417582416 |
|---|---|
| Minimum | 0.0 |
| Maximum | 21640.0 |
| Zeros | 5 |
| Zeros (%) | 5.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.5 |
| Q1 | 90.5 |
| median | 349 |
| Q3 | 2966 |
| 95-th percentile | 7050 |
| Maximum | 21640 |
| Range | 21640 |
| Interquartile range (IQR) | 2875.5 |
Descriptive statistics
| Standard deviation | 3606.081771 |
|---|---|
| Coefficient of variation (CV) | 1.757556859 |
| Kurtosis | 12.15618608 |
| Mean | 2051.758242 |
| Median Absolute Deviation (MAD) | 347 |
| Skewness | 3.14064113 |
| Sum | 186710 |
| Variance | 13003825.74 |
| Value | Count | Frequency (%) | |
| 0 | 5 | 5.0% | |
| 5 | 2 | 2.0% | |
| 69 | 2 | 2.0% | |
| 2 | 2 | 2.0% | |
| 15706 | 1 | 1.0% | |
| 1348 | 1 | 1.0% | |
| 105 | 1 | 1.0% | |
| 509 | 1 | 1.0% | |
| 181 | 1 | 1.0% | |
| 284 | 1 | 1.0% | |
| Other values (74) | 74 | 74.0% | |
| (Missing) | 9 | 9.0% |
| Value | Count | Frequency (%) | |
| 0 | 5 | 5.0% | |
| 1 | 1 | 1.0% | |
| 2 | 2 | 2.0% | |
| 3 | 1 | 1.0% | |
| 5 | 2 | 2.0% |
| Value | Count | Frequency (%) | |
| 21640 | 1 | 1.0% | |
| 15706 | 1 | 1.0% | |
| 15189 | 1 | 1.0% | |
| 8244 | 1 | 1.0% | |
| 7189 | 1 | 1.0% |
| Distinct count | 40 |
|---|---|
| Unique (%) | 40.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.86 |
|---|---|
| Minimum | 0 |
| Maximum | 334 |
| Zeros | 33 |
| Zeros (%) | 33.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 5 |
| Q3 | 25.25 |
| 95-th percentile | 108.05 |
| Maximum | 334 |
| Range | 334 |
| Interquartile range (IQR) | 25.25 |
Descriptive statistics
| Standard deviation | 51.93469481 |
|---|---|
| Coefficient of variation (CV) | 2.089086678 |
| Kurtosis | 17.36157431 |
| Mean | 24.86 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 3.807079114 |
| Sum | 2486 |
| Variance | 2697.212525 |
| Value | Count | Frequency (%) | |
| 0 | 33 | 33.0% | |
| 2 | 5 | 5.0% | |
| 4 | 5 | 5.0% | |
| 7 | 5 | 5.0% | |
| 9 | 3 | 3.0% | |
| 1 | 3 | 3.0% | |
| 5 | 3 | 3.0% | |
| 13 | 3 | 3.0% | |
| 3 | 3 | 3.0% | |
| 8 | 2 | 2.0% | |
| Other values (30) | 35 | 35.0% |
| Value | Count | Frequency (%) | |
| 0 | 33 | 33.0% | |
| 1 | 3 | 3.0% | |
| 2 | 5 | 5.0% | |
| 3 | 3 | 3.0% | |
| 4 | 5 | 5.0% |
| Value | Count | Frequency (%) | |
| 334 | 1 | 1.0% | |
| 275 | 1 | 1.0% | |
| 162 | 1 | 1.0% | |
| 142 | 1 | 1.0% | |
| 128 | 1 | 1.0% |
| Distinct count | 55 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 45 |
| Missing (%) | 45.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5433.8 |
|---|---|
| Minimum | 1.0 |
| Maximum | 84194.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 81 |
| Q1 | 606.5 |
| median | 1644 |
| Q3 | 6325 |
| 95-th percentile | 14846.5 |
| Maximum | 84194 |
| Range | 84193 |
| Interquartile range (IQR) | 5718.5 |
Descriptive statistics
| Standard deviation | 11887.22775 |
|---|---|
| Coefficient of variation (CV) | 2.187645433 |
| Kurtosis | 36.8452185 |
| Mean | 5433.8 |
| Median Absolute Deviation (MAD) | 1496 |
| Skewness | 5.645648555 |
| Sum | 298859 |
| Variance | 141306183.7 |
| Value | Count | Frequency (%) | |
| 8727 | 1 | 1.0% | |
| 11051 | 1 | 1.0% | |
| 226 | 1 | 1.0% | |
| 5080 | 1 | 1.0% | |
| 1700 | 1 | 1.0% | |
| 67 | 1 | 1.0% | |
| 93 | 1 | 1.0% | |
| 216 | 1 | 1.0% | |
| 1644 | 1 | 1.0% | |
| 11986 | 1 | 1.0% | |
| Other values (45) | 45 | 45.0% | |
| (Missing) | 45 | 45.0% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 1.0% | |
| 19 | 1 | 1.0% | |
| 67 | 1 | 1.0% | |
| 87 | 1 | 1.0% | |
| 93 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 84194 | 1 | 1.0% | |
| 21064 | 1 | 1.0% | |
| 20233 | 1 | 1.0% | |
| 12538 | 1 | 1.0% | |
| 11986 | 1 | 1.0% |
| Distinct count | 39 |
|---|---|
| Unique (%) | 39.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.43 |
|---|---|
| Minimum | 0 |
| Maximum | 433 |
| Zeros | 54 |
| Zeros (%) | 54.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 36 |
| 95-th percentile | 151.35 |
| Maximum | 433 |
| Range | 433 |
| Interquartile range (IQR) | 36 |
Descriptive statistics
| Standard deviation | 62.83443934 |
|---|---|
| Coefficient of variation (CV) | 2.135047208 |
| Kurtosis | 17.80721109 |
| Mean | 29.43 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.67601681 |
| Sum | 2943 |
| Variance | 3948.166768 |
| Value | Count | Frequency (%) | |
| 0 | 54 | 54.0% | |
| 54 | 3 | 3.0% | |
| 1 | 2 | 2.0% | |
| 2 | 2 | 2.0% | |
| 3 | 2 | 2.0% | |
| 13 | 2 | 2.0% | |
| 20 | 2 | 2.0% | |
| 36 | 2 | 2.0% | |
| 64 | 1 | 1.0% | |
| 19 | 1 | 1.0% | |
| Other values (29) | 29 | 29.0% |
| Value | Count | Frequency (%) | |
| 0 | 54 | 54.0% | |
| 1 | 2 | 2.0% | |
| 2 | 2 | 2.0% | |
| 3 | 2 | 2.0% | |
| 4 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 433 | 1 | 1.0% | |
| 227 | 1 | 1.0% | |
| 202 | 1 | 1.0% | |
| 177 | 1 | 1.0% | |
| 158 | 1 | 1.0% |
| Distinct count | 100 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 373203.29 |
|---|---|
| Minimum | 0 |
| Maximum | 3694345 |
| Zeros | 1 |
| Zeros (%) | 1.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 52.75 |
| Q1 | 19537.25 |
| median | 162573.5 |
| Q3 | 453416.5 |
| 95-th percentile | 1458854.45 |
| Maximum | 3694345 |
| Range | 3694345 |
| Interquartile range (IQR) | 433879.25 |
Descriptive statistics
| Standard deviation | 604448.7549 |
|---|---|
| Coefficient of variation (CV) | 1.619623329 |
| Kurtosis | 12.51687137 |
| Mean | 373203.29 |
| Median Absolute Deviation (MAD) | 153016 |
| Skewness | 3.13165854 |
| Sum | 37320329 |
| Variance | 3.653582973e+11 |
| Value | Count | Frequency (%) | |
| 205566 | 1 | 1.0% | |
| 1216872 | 1 | 1.0% | |
| 758606 | 1 | 1.0% | |
| 22351 | 1 | 1.0% | |
| 204880 | 1 | 1.0% | |
| 161877 | 1 | 1.0% | |
| 833878 | 1 | 1.0% | |
| 5 | 1 | 1.0% | |
| 447325 | 1 | 1.0% | |
| 32606 | 1 | 1.0% | |
| Other values (90) | 90 | 90.0% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 1.0% | |
| 1 | 1 | 1.0% | |
| 3 | 1 | 1.0% | |
| 5 | 1 | 1.0% | |
| 10 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 3694345 | 1 | 1.0% | |
| 3155702 | 1 | 1.0% | |
| 1791137 | 1 | 1.0% | |
| 1515306 | 1 | 1.0% | |
| 1508548 | 1 | 1.0% |
| Distinct count | 93 |
|---|---|
| Unique (%) | 93.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8772.65 |
|---|---|
| Minimum | -459 |
| Maximum | 101446 |
| Zeros | 5 |
| Zeros (%) | 5.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | -459 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 366 |
| median | 3265.5 |
| Q3 | 9866 |
| 95-th percentile | 29829.45 |
| Maximum | 101446 |
| Range | 101905 |
| Interquartile range (IQR) | 9500 |
Descriptive statistics
| Standard deviation | 15352.46697 |
|---|---|
| Coefficient of variation (CV) | 1.750037557 |
| Kurtosis | 17.62878302 |
| Mean | 8772.65 |
| Median Absolute Deviation (MAD) | 3252 |
| Skewness | 3.777729645 |
| Sum | 877265 |
| Variance | 235698242.1 |
| Value | Count | Frequency (%) | |
| 0 | 5 | 5.0% | |
| 4 | 2 | 2.0% | |
| 11 | 2 | 2.0% | |
| 300 | 2 | 2.0% | |
| 6063 | 1 | 1.0% | |
| 10403 | 1 | 1.0% | |
| 16935 | 1 | 1.0% | |
| 2469 | 1 | 1.0% | |
| 39 | 1 | 1.0% | |
| 5433 | 1 | 1.0% | |
| Other values (83) | 83 | 83.0% |
| Value | Count | Frequency (%) | |
| -459 | 1 | 1.0% | |
| 0 | 5 | 5.0% | |
| 1 | 1 | 1.0% | |
| 4 | 2 | 2.0% | |
| 10 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 101446 | 1 | 1.0% | |
| 81172 | 1 | 1.0% | |
| 48533 | 1 | 1.0% | |
| 44787 | 1 | 1.0% | |
| 40535 | 1 | 1.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 800.0 B |
| US |
|---|
| Value | Count | Frequency (%) | |
| US | 100 | 100.0% |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
ISO3166_2
Categorical
| Distinct count | 47 |
|---|---|
| Unique (%) | 47.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 800.0 B |
| PA | 5 |
|---|---|
| CT | 4 |
| UT | 3 |
| OR | 3 |
| MI | 3 |
| Other values (42) |
| Value | Count | Frequency (%) | |
| PA | 5 | 5.0% | |
| CT | 4 | 4.0% | |
| UT | 3 | 3.0% | |
| OR | 3 | 3.0% | |
| MI | 3 | 3.0% | |
| NH | 3 | 3.0% | |
| SD | 3 | 3.0% | |
| TX | 3 | 3.0% | |
| MT | 3 | 3.0% | |
| WY | 3 | 3.0% | |
| Other values (37) | 67 | 67.0% |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
| Distinct count | 1 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 800.0 B |
| Minimum | 2020-08-07 12:04:04.675800 |
|---|---|
| Maximum | 2020-08-07 12:04:04.675800 |
| Distinct count | 1 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 100.0 B |
| False |
|---|
| Value | Count | Frequency (%) | |
| False | 100 | 100.0% |
| Distinct count | 71 |
|---|---|
| Unique (%) | 98.6% |
| Missing | 28 |
| Missing (%) | 28.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1082.9583333333333 |
|---|---|
| Minimum | 2.0 |
| Maximum | 7226.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 13.1 |
| Q1 | 123.75 |
| median | 449 |
| Q3 | 1427.5 |
| 95-th percentile | 4604.55 |
| Maximum | 7226 |
| Range | 7224 |
| Interquartile range (IQR) | 1303.75 |
Descriptive statistics
| Standard deviation | 1535.146058 |
|---|---|
| Coefficient of variation (CV) | 1.41754859 |
| Kurtosis | 4.315520849 |
| Mean | 1082.958333 |
| Median Absolute Deviation (MAD) | 392 |
| Skewness | 2.134122455 |
| Sum | 77973 |
| Variance | 2356673.421 |
| Value | Count | Frequency (%) | |
| 55 | 2 | 2.0% | |
| 7226 | 1 | 1.0% | |
| 325 | 1 | 1.0% | |
| 682 | 1 | 1.0% | |
| 983 | 1 | 1.0% | |
| 230 | 1 | 1.0% | |
| 390 | 1 | 1.0% | |
| 127 | 1 | 1.0% | |
| 766 | 1 | 1.0% | |
| 988 | 1 | 1.0% | |
| Other values (61) | 61 | 61.0% | |
| (Missing) | 28 | 28.0% |
| Value | Count | Frequency (%) | |
| 2 | 1 | 1.0% | |
| 4 | 1 | 1.0% | |
| 6 | 1 | 1.0% | |
| 12 | 1 | 1.0% | |
| 14 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 7226 | 1 | 1.0% | |
| 5522 | 1 | 1.0% | |
| 5328 | 1 | 1.0% | |
| 4626 | 1 | 1.0% | |
| 4587 | 1 | 1.0% |
| Distinct count | 48 |
|---|---|
| Unique (%) | 66.7% |
| Missing | 28 |
| Missing (%) | 28.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.763888888888889 |
|---|---|
| Minimum | -589.0 |
| Maximum | 482.0 |
| Zeros | 7 |
| Zeros (%) | 7.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | -589 |
|---|---|
| 5-th percentile | -86.9 |
| Q1 | -5 |
| median | 1.5 |
| Q3 | 17.25 |
| 95-th percentile | 181 |
| Maximum | 482 |
| Range | 1071 |
| Interquartile range (IQR) | 22.25 |
Descriptive statistics
| Standard deviation | 125.6863403 |
|---|---|
| Coefficient of variation (CV) | 16.18858051 |
| Kurtosis | 10.84394672 |
| Mean | 7.763888889 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | -1.077087314 |
| Sum | 559 |
| Variance | 15797.05614 |
| Value | Count | Frequency (%) | |
| 0 | 7 | 7.0% | |
| -1 | 5 | 5.0% | |
| -3 | 4 | 4.0% | |
| 2 | 3 | 3.0% | |
| -36 | 2 | 2.0% | |
| 4 | 2 | 2.0% | |
| -5 | 2 | 2.0% | |
| 15 | 2 | 2.0% | |
| 181 | 2 | 2.0% | |
| 5 | 2 | 2.0% | |
| Other values (38) | 41 | 41.0% | |
| (Missing) | 28 | 28.0% |
| Value | Count | Frequency (%) | |
| -589 | 1 | 1.0% | |
| -420 | 1 | 1.0% | |
| -234 | 1 | 1.0% | |
| -121 | 1 | 1.0% | |
| -59 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 482 | 1 | 1.0% | |
| 307 | 1 | 1.0% | |
| 233 | 1 | 1.0% | |
| 181 | 2 | 2.0% | |
| 123 | 1 | 1.0% |
| Distinct count | 55 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 45 |
| Missing (%) | 45.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5433.8 |
|---|---|
| Minimum | 1.0 |
| Maximum | 84194.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 81 |
| Q1 | 606.5 |
| median | 1644 |
| Q3 | 6325 |
| 95-th percentile | 14846.5 |
| Maximum | 84194 |
| Range | 84193 |
| Interquartile range (IQR) | 5718.5 |
Descriptive statistics
| Standard deviation | 11887.22775 |
|---|---|
| Coefficient of variation (CV) | 2.187645433 |
| Kurtosis | 36.8452185 |
| Mean | 5433.8 |
| Median Absolute Deviation (MAD) | 1496 |
| Skewness | 5.645648555 |
| Sum | 298859 |
| Variance | 141306183.7 |
| Value | Count | Frequency (%) | |
| 8727 | 1 | 1.0% | |
| 11051 | 1 | 1.0% | |
| 226 | 1 | 1.0% | |
| 5080 | 1 | 1.0% | |
| 1700 | 1 | 1.0% | |
| 67 | 1 | 1.0% | |
| 93 | 1 | 1.0% | |
| 216 | 1 | 1.0% | |
| 1644 | 1 | 1.0% | |
| 11986 | 1 | 1.0% | |
| Other values (45) | 45 | 45.0% | |
| (Missing) | 45 | 45.0% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 1.0% | |
| 19 | 1 | 1.0% | |
| 67 | 1 | 1.0% | |
| 87 | 1 | 1.0% | |
| 93 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 84194 | 1 | 1.0% | |
| 21064 | 1 | 1.0% | |
| 20233 | 1 | 1.0% | |
| 12538 | 1 | 1.0% | |
| 11986 | 1 | 1.0% |
| Distinct count | 39 |
|---|---|
| Unique (%) | 70.9% |
| Missing | 45 |
| Missing (%) | 45.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 53.50909090909091 |
|---|---|
| Minimum | 0.0 |
| Maximum | 433.0 |
| Zeros | 9 |
| Zeros (%) | 9.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3 |
| median | 23 |
| Q3 | 61 |
| 95-th percentile | 184.5 |
| Maximum | 433 |
| Range | 433 |
| Interquartile range (IQR) | 58 |
Descriptive statistics
| Standard deviation | 76.9804864 |
|---|---|
| Coefficient of variation (CV) | 1.438643137 |
| Kurtosis | 10.29746183 |
| Mean | 53.50909091 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | 2.769382348 |
| Sum | 2943 |
| Variance | 5925.995286 |
| Value | Count | Frequency (%) | |
| 0 | 9 | 9.0% | |
| 54 | 3 | 3.0% | |
| 2 | 2 | 2.0% | |
| 20 | 2 | 2.0% | |
| 13 | 2 | 2.0% | |
| 1 | 2 | 2.0% | |
| 3 | 2 | 2.0% | |
| 36 | 2 | 2.0% | |
| 133 | 1 | 1.0% | |
| 10 | 1 | 1.0% | |
| Other values (29) | 29 | 29.0% | |
| (Missing) | 45 | 45.0% |
| Value | Count | Frequency (%) | |
| 0 | 9 | 9.0% | |
| 1 | 2 | 2.0% | |
| 2 | 2 | 2.0% | |
| 3 | 2 | 2.0% | |
| 4 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 433 | 1 | 1.0% | |
| 227 | 1 | 1.0% | |
| 202 | 1 | 1.0% | |
| 177 | 1 | 1.0% | |
| 158 | 1 | 1.0% |
| Distinct count | 38 |
|---|---|
| Unique (%) | 92.7% |
| Missing | 59 |
| Missing (%) | 59.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 436.8292682926829 |
|---|---|
| Minimum | 2.0 |
| Maximum | 2450.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 38 |
| median | 174 |
| Q3 | 598 |
| 95-th percentile | 1523 |
| Maximum | 2450 |
| Range | 2448 |
| Interquartile range (IQR) | 560 |
Descriptive statistics
| Standard deviation | 573.4705268 |
|---|---|
| Coefficient of variation (CV) | 1.312802434 |
| Kurtosis | 2.638853783 |
| Mean | 436.8292683 |
| Median Absolute Deviation (MAD) | 161 |
| Skewness | 1.700454643 |
| Sum | 17910 |
| Variance | 328868.4451 |
| Value | Count | Frequency (%) | |
| 9 | 2 | 2.0% | |
| 2 | 2 | 2.0% | |
| 13 | 2 | 2.0% | |
| 1523 | 1 | 1.0% | |
| 231 | 1 | 1.0% | |
| 38 | 1 | 1.0% | |
| 67 | 1 | 1.0% | |
| 81 | 1 | 1.0% | |
| 598 | 1 | 1.0% | |
| 174 | 1 | 1.0% | |
| Other values (28) | 28 | 28.0% | |
| (Missing) | 59 | 59.0% |
| Value | Count | Frequency (%) | |
| 2 | 2 | 2.0% | |
| 4 | 1 | 1.0% | |
| 9 | 2 | 2.0% | |
| 12 | 1 | 1.0% | |
| 13 | 2 | 2.0% |
| Value | Count | Frequency (%) | |
| 2450 | 1 | 1.0% | |
| 1534 | 1 | 1.0% | |
| 1523 | 1 | 1.0% | |
| 1329 | 1 | 1.0% | |
| 1312 | 1 | 1.0% |
| Distinct count | 27 |
|---|---|
| Unique (%) | 67.5% |
| Missing | 60 |
| Missing (%) | 60.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.025 |
|---|---|
| Minimum | -76.0 |
| Maximum | 42.0 |
| Zeros | 7 |
| Zeros (%) | 7.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | -76 |
|---|---|
| 5-th percentile | -38.3 |
| Q1 | -5 |
| median | 0 |
| Q3 | 10.25 |
| 95-th percentile | 31.25 |
| Maximum | 42 |
| Range | 118 |
| Interquartile range (IQR) | 15.25 |
Descriptive statistics
| Standard deviation | 21.8168219 |
|---|---|
| Coefficient of variation (CV) | 872.6728761 |
| Kurtosis | 3.144090629 |
| Mean | 0.025 |
| Median Absolute Deviation (MAD) | 7.5 |
| Skewness | -1.05633309 |
| Sum | 1 |
| Variance | 475.9737179 |
| Value | Count | Frequency (%) | |
| 0 | 7 | 7.0% | |
| 2 | 4 | 4.0% | |
| -3 | 3 | 3.0% | |
| -11 | 2 | 2.0% | |
| -5 | 2 | 2.0% | |
| 11 | 1 | 1.0% | |
| 36 | 1 | 1.0% | |
| 28 | 1 | 1.0% | |
| -33 | 1 | 1.0% | |
| -38 | 1 | 1.0% | |
| Other values (17) | 17 | 17.0% | |
| (Missing) | 60 | 60.0% |
| Value | Count | Frequency (%) | |
| -76 | 1 | 1.0% | |
| -44 | 1 | 1.0% | |
| -38 | 1 | 1.0% | |
| -33 | 1 | 1.0% | |
| -21 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 42 | 1 | 1.0% | |
| 36 | 1 | 1.0% | |
| 31 | 1 | 1.0% | |
| 30 | 1 | 1.0% | |
| 28 | 1 | 1.0% |
| Distinct count | 11 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 89 |
| Missing (%) | 89.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 887.5454545454545 |
|---|---|
| Minimum | 101.0 |
| Maximum | 2323.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 101 |
|---|---|
| 5-th percentile | 127.5 |
| Q1 | 256.5 |
| median | 483 |
| Q3 | 1575 |
| 95-th percentile | 2079.5 |
| Maximum | 2323 |
| Range | 2222 |
| Interquartile range (IQR) | 1318.5 |
Descriptive statistics
| Standard deviation | 799.3893124 |
|---|---|
| Coefficient of variation (CV) | 0.9006742227 |
| Kurtosis | -1.050966567 |
| Mean | 887.5454545 |
| Median Absolute Deviation (MAD) | 329 |
| Skewness | 0.753947867 |
| Sum | 9763 |
| Variance | 639023.2727 |
| Value | Count | Frequency (%) | |
| 2323 | 1 | 1.0% | |
| 1325 | 1 | 1.0% | |
| 1825 | 1 | 1.0% | |
| 154 | 1 | 1.0% | |
| 1836 | 1 | 1.0% | |
| 483 | 1 | 1.0% | |
| 405 | 1 | 1.0% | |
| 798 | 1 | 1.0% | |
| 223 | 1 | 1.0% | |
| 290 | 1 | 1.0% | |
| (Missing) | 89 | 89.0% |
| Value | Count | Frequency (%) | |
| 101 | 1 | 1.0% | |
| 154 | 1 | 1.0% | |
| 223 | 1 | 1.0% | |
| 290 | 1 | 1.0% | |
| 405 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 2323 | 1 | 1.0% | |
| 1836 | 1 | 1.0% | |
| 1825 | 1 | 1.0% | |
| 1325 | 1 | 1.0% | |
| 798 | 1 | 1.0% |
| Distinct count | 9 |
|---|---|
| Unique (%) | 81.8% |
| Missing | 89 |
| Missing (%) | 89.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.0 |
|---|---|
| Minimum | 0.0 |
| Maximum | 34.0 |
| Zeros | 2 |
| Zeros (%) | 2.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3.5 |
| median | 6 |
| Q3 | 17.5 |
| 95-th percentile | 33.5 |
| Maximum | 34 |
| Range | 34 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 12.23110788 |
|---|---|
| Coefficient of variation (CV) | 1.01925899 |
| Kurtosis | -0.1762543253 |
| Mean | 12 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 1.003147708 |
| Sum | 132 |
| Variance | 149.6 |
| Value | Count | Frequency (%) | |
| 6 | 2 | 2.0% | |
| 0 | 2 | 2.0% | |
| 2 | 1 | 1.0% | |
| 5 | 1 | 1.0% | |
| 17 | 1 | 1.0% | |
| 11 | 1 | 1.0% | |
| 18 | 1 | 1.0% | |
| 33 | 1 | 1.0% | |
| 34 | 1 | 1.0% | |
| (Missing) | 89 | 89.0% |
| Value | Count | Frequency (%) | |
| 0 | 2 | 2.0% | |
| 2 | 1 | 1.0% | |
| 5 | 1 | 1.0% | |
| 6 | 2 | 2.0% | |
| 11 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 34 | 1 | 1.0% | |
| 33 | 1 | 1.0% | |
| 18 | 1 | 1.0% | |
| 17 | 1 | 1.0% | |
| 11 | 1 | 1.0% |
| Distinct count | 33 |
|---|---|
| Unique (%) | 91.7% |
| Missing | 64 |
| Missing (%) | 64.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 230.30555555555554 |
|---|---|
| Minimum | 2.0 |
| Maximum | 2020.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 5.5 |
| Q1 | 29.75 |
| median | 81 |
| Q3 | 189.5 |
| 95-th percentile | 1016 |
| Maximum | 2020 |
| Range | 2018 |
| Interquartile range (IQR) | 159.75 |
Descriptive statistics
| Standard deviation | 412.5396479 |
|---|---|
| Coefficient of variation (CV) | 1.791270935 |
| Kurtosis | 10.14691888 |
| Mean | 230.3055556 |
| Median Absolute Deviation (MAD) | 62.5 |
| Skewness | 3.022249252 |
| Sum | 8291 |
| Variance | 170188.9611 |
| Value | Count | Frequency (%) | |
| 99 | 2 | 2.0% | |
| 81 | 2 | 2.0% | |
| 6 | 2 | 2.0% | |
| 2020 | 1 | 1.0% | |
| 136 | 1 | 1.0% | |
| 35 | 1 | 1.0% | |
| 43 | 1 | 1.0% | |
| 45 | 1 | 1.0% | |
| 730 | 1 | 1.0% | |
| 96 | 1 | 1.0% | |
| Other values (23) | 23 | 23.0% | |
| (Missing) | 64 | 64.0% |
| Value | Count | Frequency (%) | |
| 2 | 1 | 1.0% | |
| 4 | 1 | 1.0% | |
| 6 | 2 | 2.0% | |
| 7 | 1 | 1.0% | |
| 11 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 2020 | 1 | 1.0% | |
| 1169 | 1 | 1.0% | |
| 965 | 1 | 1.0% | |
| 730 | 1 | 1.0% | |
| 671 | 1 | 1.0% |
| Distinct count | 20 |
|---|---|
| Unique (%) | 55.6% |
| Missing | 64 |
| Missing (%) | 64.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -4.166666666666667 |
|---|---|
| Minimum | -62.0 |
| Maximum | 40.0 |
| Zeros | 8 |
| Zeros (%) | 8.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | -62 |
|---|---|
| 5-th percentile | -33.5 |
| Q1 | -7.25 |
| median | 0 |
| Q3 | 2.5 |
| 95-th percentile | 12.75 |
| Maximum | 40 |
| Range | 102 |
| Interquartile range (IQR) | 9.75 |
Descriptive statistics
| Standard deviation | 17.37239189 |
|---|---|
| Coefficient of variation (CV) | -4.169374054 |
| Kurtosis | 4.700234208 |
| Mean | -4.166666667 |
| Median Absolute Deviation (MAD) | 4.5 |
| Skewness | -1.332863063 |
| Sum | -150 |
| Variance | 301.8 |
| Value | Count | Frequency (%) | |
| 0 | 8 | 8.0% | |
| -20 | 3 | 3.0% | |
| 1 | 3 | 3.0% | |
| 4 | 2 | 2.0% | |
| -3 | 2 | 2.0% | |
| -8 | 2 | 2.0% | |
| 5 | 2 | 2.0% | |
| 7 | 2 | 2.0% | |
| -1 | 1 | 1.0% | |
| -5 | 1 | 1.0% | |
| Other values (10) | 10 | 10.0% | |
| (Missing) | 64 | 64.0% |
| Value | Count | Frequency (%) | |
| -62 | 1 | 1.0% | |
| -53 | 1 | 1.0% | |
| -27 | 1 | 1.0% | |
| -20 | 3 | 3.0% | |
| -15 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 40 | 1 | 1.0% | |
| 15 | 1 | 1.0% | |
| 12 | 1 | 1.0% | |
| 7 | 2 | 2.0% | |
| 5 | 2 | 2.0% |
| Distinct count | 6 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 94 |
| Missing (%) | 94.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 146.16666666666666 |
|---|---|
| Minimum | 94.0 |
| Maximum | 174.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 94 |
|---|---|
| 5-th percentile | 102.25 |
| Q1 | 134.5 |
| median | 158.5 |
| Q3 | 163.75 |
| 95-th percentile | 171.75 |
| Maximum | 174 |
| Range | 80 |
| Interquartile range (IQR) | 29.25 |
Descriptive statistics
| Standard deviation | 30.0893115 |
|---|---|
| Coefficient of variation (CV) | 0.205856179 |
| Kurtosis | 0.8526698983 |
| Mean | 146.1666667 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | -1.286745243 |
| Sum | 877 |
| Variance | 905.3666667 |
| Value | Count | Frequency (%) | |
| 157 | 1 | 1.0% | |
| 174 | 1 | 1.0% | |
| 160 | 1 | 1.0% | |
| 94 | 1 | 1.0% | |
| 127 | 1 | 1.0% | |
| 165 | 1 | 1.0% | |
| (Missing) | 94 | 94.0% |
| Value | Count | Frequency (%) | |
| 94 | 1 | 1.0% | |
| 127 | 1 | 1.0% | |
| 157 | 1 | 1.0% | |
| 160 | 1 | 1.0% | |
| 165 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 174 | 1 | 1.0% | |
| 165 | 1 | 1.0% | |
| 160 | 1 | 1.0% | |
| 157 | 1 | 1.0% | |
| 127 | 1 | 1.0% |
| Distinct count | 5 |
|---|---|
| Unique (%) | 83.3% |
| Missing | 94 |
| Missing (%) | 94.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.3333333333333335 |
|---|---|
| Minimum | 0.0 |
| Maximum | 7.0 |
| Zeros | 1 |
| Zeros (%) | 1.0% |
| Memory size | 800.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.5 |
| Q1 | 2.25 |
| median | 3 |
| Q3 | 4.5 |
| 95-th percentile | 6.5 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 2.25 |
Descriptive statistics
| Standard deviation | 2.422120283 |
|---|---|
| Coefficient of variation (CV) | 0.726636085 |
| Kurtosis | 0.1588326446 |
| Mean | 3.333333333 |
| Median Absolute Deviation (MAD) | 1.5 |
| Skewness | 0.304954452 |
| Sum | 20 |
| Variance | 5.866666667 |
| Value | Count | Frequency (%) | |
| 3 | 2 | 2.0% | |
| 7 | 1 | 1.0% | |
| 0 | 1 | 1.0% | |
| 5 | 1 | 1.0% | |
| 2 | 1 | 1.0% | |
| (Missing) | 94 | 94.0% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 1.0% | |
| 2 | 1 | 1.0% | |
| 3 | 2 | 2.0% | |
| 5 | 1 | 1.0% | |
| 7 | 1 | 1.0% |
| Value | Count | Frequency (%) | |
| 7 | 1 | 1.0% | |
| 5 | 1 | 1.0% | |
| 3 | 2 | 2.0% | |
| 2 | 1 | 1.0% | |
| 0 | 1 | 1.0% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
First rows
| COUNTRY_REGION | PROVINCE_STATE | DATE | POSITIVE | POSITIVE_SINCE_PREVIOUS_DAY | NEGATIVE | NEGATIVE_SINCE_PREVIOUS_DAY | PENDING | PENDING_SINCE_PREVIOUS_DAY | DEATH | DEATH_SINCE_PREVIOUS_DAY | HOSPITALIZED | HOSPITALIZED_SINCE_PREVIOUS_DAY | TOTAL | TOTAL_SINCE_PREVIOUS_DAY | ISO3166_1 | ISO3166_2 | LAST_UPDATED_DATE | LAST_REPORTED_FLAG | HOSPITALIZEDCURRENTLY | HOSPITALIZEDCURRENTLYINCREASE | HOSPITALIZEDCUMULATIVE | HOSPITALIZEDCUMULATIVEINCREASE | INICUCURRENTLY | INICUCURRENTLYINCREASE | INICUCUMULATIVE | INICUCUMULATIVEINCREASE | ONVENTILATORCURRENTLY | ONVENTILATORCURRENTLYINCREASE | ONVENTILATORCUMULATIVE | ONVENTILATORCUMULATIVEINCREASE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | United States | North Carolina | 2020-05-23 | 22725 | 1107 | 306857.0 | 25251 | NaN | NaN | 737.0 | 9 | NaN | 0 | 329582 | 26358 | US | NC | 2020-08-07 12:04:04.675800 | False | 589.0 | 21.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | United States | Guam | 2020-04-13 | 133 | 0 | 770.0 | 77 | NaN | NaN | 5.0 | 0 | NaN | 0 | 903 | 77 | US | GU | 2020-08-07 12:04:04.675800 | False | 12.0 | -1.0 | NaN | NaN | 2.0 | 0.0 | NaN | NaN | 2.0 | 0.0 | NaN | NaN |
| 2 | United States | Oregon | 2020-07-15 | 13081 | 276 | 298705.0 | 6054 | NaN | NaN | 247.0 | 3 | 1290.0 | 36 | 311786 | 6330 | US | OR | 2020-08-07 12:04:04.675800 | False | 207.0 | -28.0 | 1290.0 | 36.0 | 53.0 | -11.0 | NaN | NaN | 30.0 | -5.0 | NaN | NaN |
Last rows
| COUNTRY_REGION | PROVINCE_STATE | DATE | POSITIVE | POSITIVE_SINCE_PREVIOUS_DAY | NEGATIVE | NEGATIVE_SINCE_PREVIOUS_DAY | PENDING | PENDING_SINCE_PREVIOUS_DAY | DEATH | DEATH_SINCE_PREVIOUS_DAY | HOSPITALIZED | HOSPITALIZED_SINCE_PREVIOUS_DAY | TOTAL | TOTAL_SINCE_PREVIOUS_DAY | ISO3166_1 | ISO3166_2 | LAST_UPDATED_DATE | LAST_REPORTED_FLAG | HOSPITALIZEDCURRENTLY | HOSPITALIZEDCURRENTLYINCREASE | HOSPITALIZEDCUMULATIVE | HOSPITALIZEDCUMULATIVEINCREASE | INICUCURRENTLY | INICUCURRENTLYINCREASE | INICUCUMULATIVE | INICUCUMULATIVEINCREASE | ONVENTILATORCURRENTLY | ONVENTILATORCURRENTLYINCREASE | ONVENTILATORCUMULATIVE | ONVENTILATORCUMULATIVEINCREASE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97 | United States | Puerto Rico | 2020-03-21 | 21 | 7 | 143.0 | 29 | 71.0 | 19.0 | NaN | 0 | NaN | 0 | 235 | 36 | US | PR | 2020-08-07 12:04:04.675800 | False | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 98 | United States | Nebraska | 2020-05-09 | 7831 | 641 | 35145.0 | 1923 | NaN | NaN | 92.0 | 2 | NaN | 0 | 42976 | 2564 | US | NE | 2020-08-07 12:04:04.675800 | False | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 99 | United States | South Dakota | 2020-07-06 | 7105 | 42 | 77198.0 | 258 | NaN | NaN | 97.0 | 0 | 692.0 | 1 | 84303 | 300 | US | SD | 2020-08-07 12:04:04.675800 | False | 59.0 | 0.0 | 692.0 | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |